ExternalDepositoryTender

Entity Definition

Logical Name : ExternalDepositoryTender
Physical Name : AS_TND_EXTDST

A set of tender repository totals for each type of tender in an EXTERNAL DEPOSITORY

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TenderRepositoryID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer ExternalDepository(LO_EXTDST)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
OpenMediaUnitQuantity The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. QU_OPN_MD_UN QuantityInteger integer
CloseBalanceAmount The closing system maintained tender balance in the EXTERNAL DEPOSITORY before formalizing the closing of an external depository settlement period. MO_CL_BLNC_AMT Money decimal(16,5)
CloseMediaUnitQuantity The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. QU_CL_MD_UN QuantityInteger integer
CountedBalanceAmount The counted tender balance in the SAFE before the fomal closing of a safe settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. MO_CNT_BLNC_AMT Money decimal(16,5)
CountedMediaUnitQuantity The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. QU_CNT_MD_UN QuantityInteger integer
OverUnderBalanceAmount The variance between closing balance amount and counted balance amount before the formal closing of a safe settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) MO_OVR_UND_BLNC_AMT Money decimal(16,5)
OverUnderMediaUnitQuantity The variance between closing media unit quantity and counted media unit quantity before the closing of a safe settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) QU_OVR_UND_MD_UN QuantityInteger integer
DepositFromSafeAmount The running sum of deposits made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period prior to the formal close of the period This is money moving from the store safe into the bank. MO_DS_FM_SF_AMT Money decimal(16,5)
DepositFromSafeMediaUnitQuantity The running sum of tender media unit quantities made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period prior to the formal close of the period This is money moving from the store safe into the bank. QU_DS_FM_SF_MD_UN QuantityInteger integer
ReceiptToSafeAmount The running sum of tender withdrawn from this external depository (bank) and received into store safes for an external depository settlement period prior to the formal closing of that period This represents tender pulled out from a bank and received into a safe for use in making change. MO_RCT_TO_SF_AMT Money decimal(16,5)
ReceiptToSafeMediaUnitQuantity The running sum of tender media unit quantities withdrawn from this external depository (bank) and received into store safes for an external depository settlement period prior to the formal close of that period. This represents tender pulled out from a bank and received into a safe for use in making change. QU_RCT_TO_SF_MD_UN QuantityInteger integer

Relationships

Parent Entity Verb Phrase Child Entity
ExternalDepository contains ExternalDepositoryTender
Tender is tracked through ExternalDepositoryTender

Logical Views containing ExternalDepositoryTender

Logical View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03110 - Reporting - Store Operations - Tender Settlement
Logical 03160 - Reporting - Store Operations - Till View